﻿<?xml version="1.0" encoding="utf-8" ?>
<DbDataRequest connection="$UserLoginDBConnection$" type="$UserLoginDbType$" defaultFormatter="bizobj User">
  <SqlStatement hasResults="true">
    SELECT  u.id, u.userName, u.password,u.companyId FROM Users u 
    INNER JOIN Companies c ON c.anonymousId = u.id WHERE c.id=@id
  </SqlStatement>
  <Param name="id" type="UniqueIdentifier"/>
 </DbDataRequest>